DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on FND_GLOBAL

Line 1074: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

1070: l_olev_tbl_in(i).creation_date := SYSDATE;
1071: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1072: l_olev_tbl_in(i).last_update_date := SYSDATE;
1073: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1074: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1075: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1076: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1077: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1078: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

Line 1075: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

1071: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1072: l_olev_tbl_in(i).last_update_date := SYSDATE;
1073: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1074: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1075: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1076: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1077: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1078: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1079: i := i + 1;

Line 1076: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;

1072: l_olev_tbl_in(i).last_update_date := SYSDATE;
1073: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1074: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1075: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1076: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1077: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1078: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1079: i := i + 1;
1080: END IF;

Line 1167: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

1163: l_olev_tbl_in(i).creation_date := SYSDATE;
1164: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1165: l_olev_tbl_in(i).last_update_date := SYSDATE;
1166: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1167: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1168: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1169: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1170: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1171: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

Line 1168: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

1164: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1165: l_olev_tbl_in(i).last_update_date := SYSDATE;
1166: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1167: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1168: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1169: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1170: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1171: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1172: i := i + 1;

Line 1169: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;

1165: l_olev_tbl_in(i).last_update_date := SYSDATE;
1166: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1167: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1168: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1169: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1170: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1171: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1172: i := i + 1;
1173: END IF;

Line 1246: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

1242: l_olev_tbl_in(i).creation_date := SYSDATE;
1243: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1244: l_olev_tbl_in(i).last_update_date := SYSDATE;
1245: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1246: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1247: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1248: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1249: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1250: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

Line 1247: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

1243: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1244: l_olev_tbl_in(i).last_update_date := SYSDATE;
1245: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1246: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1247: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1248: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1249: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1250: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1251: i := i + 1;

Line 1248: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;

1244: l_olev_tbl_in(i).last_update_date := SYSDATE;
1245: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1246: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1247: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1248: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1249: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1250: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1251: i := i + 1;
1252: j := j + 1;

Line 2556: l_user_id := FND_GLOBAL.USER_ID;

2552: END IF;
2553: END LOOP;
2554:
2555: l_update_date := sysdate;
2556: l_user_id := FND_GLOBAL.USER_ID;
2557: l_login_id := FND_GLOBAL.LOGIN_ID;
2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2557: l_login_id := FND_GLOBAL.LOGIN_ID;

2553: END LOOP;
2554:
2555: l_update_date := sysdate;
2556: l_user_id := FND_GLOBAL.USER_ID;
2557: l_login_id := FND_GLOBAL.LOGIN_ID;
2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2561:

Line 2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2554:
2555: l_update_date := sysdate;
2556: l_user_id := FND_GLOBAL.USER_ID;
2557: l_login_id := FND_GLOBAL.LOGIN_ID;
2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2561:
2562: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);

Line 2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

2555: l_update_date := sysdate;
2556: l_user_id := FND_GLOBAL.USER_ID;
2557: l_login_id := FND_GLOBAL.LOGIN_ID;
2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2561:
2562: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2563: LOG_MESSAGES(' ');

Line 2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

2556: l_user_id := FND_GLOBAL.USER_ID;
2557: l_login_id := FND_GLOBAL.LOGIN_ID;
2558: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2559: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2560: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2561:
2562: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2563: LOG_MESSAGES(' ');
2564:

Line 2955: l_user_id := FND_GLOBAL.USER_ID;

2951:
2952: IF p_header_id IS NOT NULL THEN
2953:
2954: l_update_date := sysdate;
2955: l_user_id := FND_GLOBAL.USER_ID;
2956: l_login_id := FND_GLOBAL.LOGIN_ID;
2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2956: l_login_id := FND_GLOBAL.LOGIN_ID;

2952: IF p_header_id IS NOT NULL THEN
2953:
2954: l_update_date := sysdate;
2955: l_user_id := FND_GLOBAL.USER_ID;
2956: l_login_id := FND_GLOBAL.LOGIN_ID;
2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2960:

Line 2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2953:
2954: l_update_date := sysdate;
2955: l_user_id := FND_GLOBAL.USER_ID;
2956: l_login_id := FND_GLOBAL.LOGIN_ID;
2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2960:
2961: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns

Line 2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

2954: l_update_date := sysdate;
2955: l_user_id := FND_GLOBAL.USER_ID;
2956: l_login_id := FND_GLOBAL.LOGIN_ID;
2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2960:
2961: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns
2962: --no need for warranty(14 - cannot be renewed) and subscription (46 - no toplines)

Line 2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

2955: l_user_id := FND_GLOBAL.USER_ID;
2956: l_login_id := FND_GLOBAL.LOGIN_ID;
2957: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2958: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2959: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2960:
2961: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns
2962: --no need for warranty(14 - cannot be renewed) and subscription (46 - no toplines)
2963: OPEN c_top_lines(p_header_id);