DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2554: l_user_id := FND_GLOBAL.USER_ID;

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

Line 2555: l_login_id := FND_GLOBAL.LOGIN_ID;

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

Line 2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

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

Line 2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

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

Line 2951: l_user_id := FND_GLOBAL.USER_ID;

2947:
2948: IF p_header_id IS NOT NULL THEN
2949:
2950: l_update_date := sysdate;
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2952: l_login_id := FND_GLOBAL.LOGIN_ID;

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

Line 2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

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

Line 2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

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