1210: p_document_id,
1211: 'FORM_ID',
1212: p_form_id,
1213: SYSDATE,
1214: fnd_global.user_id,
1215: SYSDATE,
1216: fnd_global.user_id,
1217: fnd_global.login_id
1218: );
1212: p_form_id,
1213: SYSDATE,
1214: fnd_global.user_id,
1215: SYSDATE,
1216: fnd_global.user_id,
1217: fnd_global.login_id
1218: );
1219:
1220: END IF;
1213: SYSDATE,
1214: fnd_global.user_id,
1215: SYSDATE,
1216: fnd_global.user_id,
1217: fnd_global.login_id
1218: );
1219:
1220: END IF;
1221:
1286: To_Number(l_request_id),
1287: l_res_message,
1288: 'FORM_ID',
1289: l_form_id,
1290: fnd_global.user_id,
1291: SYSDATE,
1292: fnd_global.user_id,
1293: SYSDATE,
1294: fnd_global.login_id
1288: 'FORM_ID',
1289: l_form_id,
1290: fnd_global.user_id,
1291: SYSDATE,
1292: fnd_global.user_id,
1293: SYSDATE,
1294: fnd_global.login_id
1295: );
1296:
1290: fnd_global.user_id,
1291: SYSDATE,
1292: fnd_global.user_id,
1293: SYSDATE,
1294: fnd_global.login_id
1295: );
1296:
1297: END IF;
1298:
1350: aname => 'TO_ROLE',
1351: avalue => l_username);
1352: wf_engine.SetItemOwner(itemtype => l_itemtype,
1353: itemkey => l_itemkey,
1354: owner => fnd_global.user_name );
1355:
1356: wf_engine.StartProcess(itemtype => l_itemtype,
1357: itemkey => l_itemkey );
1358: END LOOP;
1389: p_product_code,
1390: p_request_id,
1391: SYSDATE,
1392: SYSDATE,
1393: fnd_global.user_id,
1394: SYSDATE,
1395: fnd_global.user_id);
1396:
1397: COMMIT;
1391: SYSDATE,
1392: SYSDATE,
1393: fnd_global.user_id,
1394: SYSDATE,
1395: fnd_global.user_id);
1396:
1397: COMMIT;
1398:
1399: EXCEPTION
1424: p_document_id,
1425: p_form_id,
1426: 'DATA_ENTERED',
1427: SYSDATE,
1428: fnd_global.user_id ,
1429: SYSDATE,
1430: fnd_global.user_id,
1431: fnd_global.login_id);
1432:
1426: 'DATA_ENTERED',
1427: SYSDATE,
1428: fnd_global.user_id ,
1429: SYSDATE,
1430: fnd_global.user_id,
1431: fnd_global.login_id);
1432:
1433: INSERT INTO pon_form_field_values(FORM_FIELD_VALUE_ID,
1434: FORM_ID,
1427: SYSDATE,
1428: fnd_global.user_id ,
1429: SYSDATE,
1430: fnd_global.user_id,
1431: fnd_global.login_id);
1432:
1433: INSERT INTO pon_form_field_values(FORM_FIELD_VALUE_ID,
1434: FORM_ID,
1435: OWNING_ENTITY_CODE,
1448: p_document_id,
1449: -1,
1450: -1,
1451: SYSDATE,
1452: fnd_global.user_id ,
1453: SYSDATE,
1454: fnd_global.user_id ,
1455: fnd_global.login_id,
1456: 'PRESOL'); -- bug 13484000
1450: -1,
1451: SYSDATE,
1452: fnd_global.user_id ,
1453: SYSDATE,
1454: fnd_global.user_id ,
1455: fnd_global.login_id,
1456: 'PRESOL'); -- bug 13484000
1457:
1458: END INSERT_DOC_UPLOAD_RECORD;
1451: SYSDATE,
1452: fnd_global.user_id ,
1453: SYSDATE,
1454: fnd_global.user_id ,
1455: fnd_global.login_id,
1456: 'PRESOL'); -- bug 13484000
1457:
1458: END INSERT_DOC_UPLOAD_RECORD;
1459: